{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Start","Award Data Sheet","Tech Award","Sector","Points","Lookup","Points Contingency"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":5,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Start","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Award Data Sheet","index":1,"n_rows":35,"n_cols":5,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
["Mandatory Units A"]
["Sector","Unit number","Unit Name","GLH","Assessment type"]
["Art and Design Practice",1,"Generating Ideas in Art and Design",36,"Internal"]
["Art and Design Practice",2,"Develop Practical Skills in Art and Design",36,"Internal"]
["Art and Design Practice",3,"Responding to a Client Brief",48,"External"]
["Child Development",1,"Children's Growth and Development",36,"Internal"]
["Child Development",2,"Learning Through Play",36,"Internal"]
["Child Development",3,"Supporting Children to Play, Learn and Develop",48,"External"]
["Creative Media Production",1,"Exploring Media Products",36,"Internal"]
["Creative Media Production",2,"Developing Digital Media Production Skills",36,"Internal"]
["Creative Media Production",3,"Create a Media Product in Response to a Brief",48,"External"]
["Digital Information Technology",1,"Exploring User Interface Design Principles and Project Planning Techniques",36,"Internal"]
["Digital Information Technology",2,"Collecting, Presenting and Interpreting Data",36,"Internal"]
["Digital Information Technology",3,"Effective Digital Working Practices",48,"External"]
["Engineering",1,"Exploring Engineering Sectors and Design Applications",36,"Internal"]
["Engineering",2,"Investigating an Engineering Project",36,"Internal"]
["Engineering",3,"Responding to an Engineering Brief",48,"External"]
["Enterprise",1,"Exploring Enterprises",36,"Internal"]
["Enterprise",2,"Planning for and Pitching an Enterprise Activity",36,"Internal"]
["Enterprise",3,"Promotion and Finance for Enterprise",48,"External"]
["Health and Social Care",1,"Human Lifespan Development",36,"Internal"]
["Health and Social Care",2,"Health and Social Care Services and Values",36,"Internal"]
["Health and Social Care",3,"Health and Wellbeing",48,"External"]
["Music Practice",1,"Exploring Music Products and Styles",36,"Internal"]
["Music Practice",2,"Music Skills Development",36,"Internal"]
["Music Practice",3,"Responding to a Commercial Music Brief",48,"External"]
["Performing Arts",1,"Exploring the Performing Arts",36,"Internal"]
["Performing Arts",2,"Developing Skills and Techniques in the Performing Arts",36,"Internal"]
["Performing Arts",3,"Performing to a Brief",48,"External"]
["Sport, Activity and Fitness",1,"Understand the Body and the Supporting Technology for Sport and Activity",36,"Internal"]
["Sport, Activity and Fitness",2,"The Principles of Training, Nutrition and Psychology for Sport and Activity",48,"External"]
["Sport, Activity and Fitness",3,"Applying the Principles of Sport and Activity",36,"Internal"]
["Travel and Tourism",1,"Travel and Tourism Organisations and Destinations",36,"Internal"]
["Travel and Tourism",2,"Influences on Global Travel and Tourism",48,"External"]
["Travel and Tourism",3,"Customer Needs in Travel and Tourism",36,"Internal"]

{"sheet":"Tech Award","index":2,"n_rows":31,"n_cols":32,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,27,0,28],[0,30,0,31],[2,4,2,7],[6,4,6,7],[19,9,21,11]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Points available for External Units",null,null,"Points available for Internal Units"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"U",0,null,"U",0]
[null,null,"Select Sector","Start →","Health and Social Care",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Level 1 Pass","12-17",null,"Level 1 Pass","9"]
[null,null,null,null,"1. Select your sector from the dropdown list in the cell above",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Level 1 Merit","18-23",null,"Level 1 Merit",15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Level 1 Distinction","24-29",null,"Level 2 Pass",22]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Level 2 Pass","30-35",null,"Level 2 Merit",29]
[null,null,"Assessment Type","Unit Number","Unit Name",null,null,null,"GLH","Unit Mark/Grade","Points","Unit Grade","Internal 36 GLH Grade",null,"External 48 GLH Grade",null,null,null,null,null,null,null,null,null,null,null,null,"Level 2 Merit","36-41",null,"Level 2 Distinction",36]
[null,null,null,null,null,null,null,null,null,"2. Enter the marks or grade for the units below",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Level 2 Distinction","42-48"]
[null,"Mandatory",{"$f":"IFERROR(INDEX('Award Data Sheet'!$A$3:$E$235,SMALL(IF('Award Data Sheet'!$A$3:$A$235=$E$3,ROW('Award Data Sheet'!$A$3:$A$235)),ROW(1:1))-2,5),\"\")","v":"Internal"},{"$f":"IFERROR(INDEX('Award Data Sheet'!$A$3:$E$235,SMALL(IF('Award Data Sheet'!$A$3:$A$235=$E$3,ROW('Award Data Sheet'!$A$3:$A$235)),ROW(1:1))-2,2),\"\")","v":1},{"$f":"IFERROR(INDEX('Award Data Sheet'!$A$3:$E$235,SMALL(IF('Award Data Sheet'!$A$3:$A$235=$E$3,ROW('Award Data Sheet'!$A$3:$A$235)),ROW(1:1))-2,3),\"\")","v":"Human Lifespan Development"},null,null,null,{"$f":"IFERROR(INDEX('Award Data Sheet'!$A$3:$E$235,SMALL(IF('Award Data Sheet'!$A$3:$A$235=$E$3,ROW('Award Data Sheet'!$A$3:$A$235)),ROW(1:1))-2,4),\"\")","v":36},null,{"$f":"_xlfn.IFNA(IF(C9=\"External\",VLOOKUP(J9,Points!$F$2:$H$351,MATCH(C9&\" \"&I9&\" GLH\",Points!$F$2:$H$2,0),FALSE),VLOOKUP(J9,Points!$A$2:$C$8,MATCH(C9&\" \"&I9&\" GLH\",Points!$A$2:$C$2,0),FALSE)),\"\")","v":""},{"$f":"IF(E9=\"\",\"\",VLOOKUP(SUM(N9,P9),Lookup!$K$1:$L$8,2,FALSE))","v":"U"},{"$f":"_xlfn.IFNA(IF(AND(C9=\"Internal\",I9=36),VLOOKUP(K9,Points!$B$2:$C$8,MATCH(\"Internal Grade\",Points!$B$2:$C$2,0),FALSE),\"\"),\"\")","v":""},{"$f":"IF(M9=\"\",\"\",VLOOKUP(M9,Lookup!$J$2:$K$8,2,FALSE))","v":""},{"$f":"IF(AND(C9=\"External\",I9=48),VLOOKUP(K9,Points!$G$2:$H$51,MATCH(\"48 GLH Grade\",Points!$G$2:$H$2,0),FALSE),\"No\")","v":"No"},{"$f":"IF(O9=\"\",\"\",VLOOKUP(O9,Lookup!$J$1:$K$8,2,FALSE))","v":0}]
[null,"Mandatory",{"$f":"IFERROR(INDEX('Award Data Sheet'!$A$3:$E$235,SMALL(IF('Award Data Sheet'!$A$3:$A$235=$E$3,ROW('Award Data Sheet'!$A$3:$A$235)),ROW(2:2))-2,5),\"\")","v":"Internal"},{"$f":"IFERROR(INDEX('Award Data Sheet'!$A$3:$E$235,SMALL(IF('Award Data Sheet'!$A$3:$A$235=$E$3,ROW('Award Data Sheet'!$A$3:$A$235)),ROW(2:2))-2,2),\"\")","v":2},{"$f":"IFERROR(INDEX('Award Data Sheet'!$A$3:$E$235,SMALL(IF('Award Data Sheet'!$A$3:$A$235=$E$3,ROW('Award Data Sheet'!$A$3:$A$235)),ROW(2:2))-2,3),\"\")","v":"Health and Social Care Services and Values"},null,null,null,{"$f":"IFERROR(INDEX('Award Data Sheet'!$A$3:$E$235,SMALL(IF('Award Data Sheet'!$A$3:$A$235=$E$3,ROW('Award Data Sheet'!$A$3:$A$235)),ROW(2:2))-2,4),\"\")","v":36},null,{"$f":"_xlfn.IFNA(IF(C10=\"External\",VLOOKUP(J10,Points!$F$2:$H$351,MATCH(C10&\" \"&I10&\" GLH\",Points!$F$2:$H$2,0),FALSE),VLOOKUP(J10,Points!$A$2:$C$8,MATCH(C10&\" \"&I10&\" GLH\",Points!$A$2:$C$2,0),FALSE)),\"\")","v":""},{"$f":"IF(E10=\"\",\"\",VLOOKUP(SUM(N10,P10),Lookup!$K$1:$L$8,2,FALSE))","v":"U"},{"$f":"_xlfn.IFNA(IF(AND(C10=\"Internal\",I10=36),VLOOKUP(K10,Points!$B$2:$C$8,MATCH(\"Internal Grade\",Points!$B$2:$C$2,0),FALSE),\"\"),\"\")","v":""},{"$f":"IF(M10=\"\",\"\",VLOOKUP(M10,Lookup!$J$2:$K$8,2,FALSE))","v":""},{"$f":"IF(AND(C10=\"External\",I10=48),VLOOKUP(K10,Points!$G$2:$H$51,MATCH(\"48 GLH Grade\",Points!$G$2:$H$2,0),FALSE),\"No\")","v":"No"},{"$f":"IF(O10=\"\",\"\",VLOOKUP(O10,Lookup!$J$1:$K$8,2,FALSE))","v":0}]
[null,"Mandatory",{"$f":"IFERROR(INDEX('Award Data Sheet'!$A$3:$E$235,SMALL(IF('Award Data Sheet'!$A$3:$A$235=$E$3,ROW('Award Data Sheet'!$A$3:$A$235)),ROW(3:3))-2,5),\"\")","v":"External"},{"$f":"IFERROR(INDEX('Award Data Sheet'!$A$3:$E$235,SMALL(IF('Award Data Sheet'!$A$3:$A$235=$E$3,ROW('Award Data Sheet'!$A$3:$A$235)),ROW(3:3))-2,2),\"\")","v":3},{"$f":"IFERROR(INDEX('Award Data Sheet'!$A$3:$E$235,SMALL(IF('Award Data Sheet'!$A$3:$A$235=$E$3,ROW('Award Data Sheet'!$A$3:$A$235)),ROW(3:3))-2,3),\"\")","v":"Health and Wellbeing"},null,null,null,{"$f":"IFERROR(INDEX('Award Data Sheet'!$A$3:$E$235,SMALL(IF('Award Data Sheet'!$A$3:$A$235=$E$3,ROW('Award Data Sheet'!$A$3:$A$235)),ROW(3:3))-2,4),\"\")","v":48},null,{"$f":"_xlfn.IFNA(IF(C11=\"External\",VLOOKUP(J11,Points!$F$2:$H$351,MATCH(C11&\" \"&I11&\" GLH\",Points!$F$2:$H$2,0),FALSE),VLOOKUP(J11,Points!$A$2:$C$8,MATCH(C11&\" \"&I11&\" GLH\",Points!$A$2:$C$2,0),FALSE)),\"\")","v":0},{"$f":"IF(E11=\"\",\"\",VLOOKUP(SUM(N11,P11),Lookup!$K$1:$L$8,2,FALSE))","v":"U"},{"$f":"_xlfn.IFNA(IF(AND(C11=\"Internal\",I11=36),VLOOKUP(K11,Points!$B$2:$C$8,MATCH(\"Internal Grade\",Points!$B$2:$C$2,0),FALSE),\"\"),\"\")","v":""},{"$f":"IF(M11=\"\",\"\",VLOOKUP(M11,Lookup!$J$2:$K$8,2,FALSE))","v":""},{"$f":"IF(AND(C11=\"External\",I11=48),VLOOKUP(K11,Points!$G$2:$H$51,MATCH(\"48 GLH Grade\",Points!$G$2:$H$2,0),FALSE),\"No\")","v":"U"},{"$f":"IF(O11=\"\",\"\",VLOOKUP(O11,Lookup!$J$1:$K$8,2,FALSE))","v":1}]
[null,"Mandatory",{"$f":"IFERROR(INDEX('Award Data Sheet'!$A$9:$E$235,SMALL(IF('Award Data Sheet'!$A$9:$A$235=$E$3,ROW('Award Data Sheet'!$A$9:$A$235)),ROW(4:4))-2,5),\"\")","v":""},{"$f":"IFERROR(INDEX('Award Data Sheet'!$A$9:$E$235,SMALL(IF('Award Data Sheet'!$A$9:$A$235=$E$3,ROW('Award Data Sheet'!$A$9:$A$235)),ROW(4:4))-2,2),\"\")","v":""},{"$f":"IFERROR(INDEX('Award Data Sheet'!$A$9:$E$235,SMALL(IF('Award Data Sheet'!$A$9:$A$235=$E$3,ROW('Award Data Sheet'!$A$9:$A$235)),ROW(4:4))-2,3),\"\")","v":""},null,null,null,{"$f":"IFERROR(INDEX('Award Data Sheet'!$A$9:$E$235,SMALL(IF('Award Data Sheet'!$A$9:$A$235=$E$3,ROW('Award Data Sheet'!$A$9:$A$235)),ROW(4:4))-2,4),\"\")","v":""},null,{"$f":"_xlfn.IFNA(IF(C12=\"External\",VLOOKUP(J12,Points!$F$2:$H$351,MATCH(C12&\" \"&I12&\" GLH\",Points!$F$2:$H$2,0),FALSE),VLOOKUP(J12,Points!$A$2:$C$8,MATCH(C12&\" \"&I12&\" GLH\",Points!$A$2:$C$2,0),FALSE)),\"\")","v":""},{"$f":"IF(E12=\"\",\"\",VLOOKUP(SUM(N12,P12),Lookup!$K$1:$L$8,2,FALSE))","v":""},{"$f":"_xlfn.IFNA(IF(AND(C12=\"Internal\",I12=36),VLOOKUP(K12,Points!$B$2:$C$8,MATCH(\"Internal Grade\",Points!$B$2:$C$2,0),FALSE),\"\"),\"\")","v":""},{"$f":"IF(M12=\"\",\"\",VLOOKUP(M12,Lookup!$J$2:$K$8,2,FALSE))","v":""},{"$f":"IF(AND(C12=\"External\",I12=48),VLOOKUP(K12,Points!$G$2:$H$51,MATCH(\"48 GLH Grade\",Points!$G$2:$H$2,0),FALSE),\"No\")","v":"No"},{"$f":"IF(O12=\"\",\"\",VLOOKUP(O12,Lookup!$J$1:$K$8,2,FALSE))","v":0}]
[null,"Mandatory",{"$f":"IFERROR(INDEX('Award Data Sheet'!$A$9:$E$235,SMALL(IF('Award Data Sheet'!$A$9:$A$235=$E$3,ROW('Award Data Sheet'!$A$9:$A$235)),ROW(5:5))-2,5),\"\")","v":""},{"$f":"IFERROR(INDEX('Award Data Sheet'!$A$9:$E$235,SMALL(IF('Award Data Sheet'!$A$9:$A$235=$E$3,ROW('Award Data Sheet'!$A$9:$A$235)),ROW(5:5))-2,2),\"\")","v":""},{"$f":"IFERROR(INDEX('Award Data Sheet'!$A$9:$E$235,SMALL(IF('Award Data Sheet'!$A$9:$A$235=$E$3,ROW('Award Data Sheet'!$A$9:$A$235)),ROW(5:5))-2,3),\"\")","v":""},null,null,null,{"$f":"IFERROR(INDEX('Award Data Sheet'!$A$9:$E$235,SMALL(IF('Award Data Sheet'!$A$9:$A$235=$E$3,ROW('Award Data Sheet'!$A$9:$A$235)),ROW(5:5))-2,4),\"\")","v":""},null,{"$f":"_xlfn.IFNA(IF(C13=\"External\",VLOOKUP(J13,Points!$F$2:$H$351,MATCH(C13&\" \"&I13&\" GLH\",Points!$F$2:$H$2,0),FALSE),VLOOKUP(J13,Points!$A$2:$C$8,MATCH(C13&\" \"&I13&\" GLH\",Points!$A$2:$C$2,0),FALSE)),\"\")","v":""},{"$f":"IF(E13=\"\",\"\",VLOOKUP(SUM(N13,P13),Lookup!$K$1:$L$8,2,FALSE))","v":""},{"$f":"_xlfn.IFNA(IF(AND(C13=\"Internal\",I13=36),VLOOKUP(K13,Points!$B$2:$C$8,MATCH(\"Internal Grade\",Points!$B$2:$C$2,0),FALSE),\"\"),\"\")","v":""},{"$f":"IF(M13=\"\",\"\",VLOOKUP(M13,Lookup!$J$2:$K$8,2,FALSE))","v":""},{"$f":"IF(AND(C13=\"External\",I13=48),VLOOKUP(K13,Points!$G$2:$H$51,MATCH(\"48 GLH Grade\",Points!$G$2:$H$2,0),FALSE),\"No\")","v":"No"},{"$f":"IF(O13=\"\",\"\",VLOOKUP(O13,Lookup!$J$1:$K$8,2,FALSE))","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,"Overall Grade",{"$f":"SUM(K9:K13)","v":0},{"$f":"O17","v":"U"}]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIFS(L9:L13,\"U\")","v":3},"Points",null,{"$f":"K16","v":0},null,null,{"$f":"_xlfn.IFNA(IF(OR(I17>0,I18<120),\"U\",VLOOKUP($K$16,Points!$O$2:$P$10,MATCH(\"Award Grade\",Points!$O$2:$P$2,0),TRUE)),\"\")","v":"U"}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I9:I13)","v":120}]
[]
[null,null,null,null,null,null,null,null,null,"Calculate an estimate of the externally assessed unit grades needed to reach a qualification grade based on the internally assessed unit grades. You must enter all internally assessed grades and may enter any externally assessed grades already known, then select an overall qualification grade below."]
[]
[]
[null,null,null,null,null,null,null,null,null,"Qualification Grade",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF($L$9:$L$11,\"#N/A\")","v":0}]
[null,null,null,null,null,null,null,null,null,"Bottom Grade point total",null,{"$f":"IF($L$23=\"\",0,VLOOKUP($L$23,'Points Contingency'!$A$2:$C$9,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,null,"Top Grade point total",null,{"$f":"IF($L$23=\"\",0,VLOOKUP($L$23,'Points Contingency'!$A$2:$C$9,3,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,null,"Points for externals",null,{"$f":"IF(L24-L17<0,L25-L17,L24-L17)","v":0}]
[null,null,null,null,null,null,null,null,null,"No. of 48 GLH externals",null,{"$f":"COUNTIFS($C$9:$C$60,\"External\",$I$9:I$60,48,$L$9:$L$60,\"U\")","v":1}]
[null,null,null,null,null,null,null,null,null,"Total GLH external",null,{"$f":"(L27*48)","v":48}]
[null,null,null,null,null,null,null,null,null,"Scale for 48 GLH",null,{"$f":"IFERROR(L27*48/L28,\"\")","v":1}]
[null,null,null,null,null,null,null,null,null,"Total points for externals",null,{"$f":"L26","v":0},37]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,48]

{"sheet":"Sector","index":3,"n_rows":11,"n_cols":1,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["Art and Design Practice"]
["Child Development"]
["Creative Media Production"]
["Digital Information Technology"]
["Engineering"]
["Enterprise"]
["Health and Social Care"]
["Music Practice"]
["Performing Arts"]
["Sport, Activity and Fitness"]
["Travel and Tourism"]

{"sheet":"Points","index":4,"n_rows":51,"n_cols":16,"rows_kept":51,"cut":false,"hidden":true,"merged":[]}
["Internal",null,null,null,null,"External"]
[null,"Internal 36 GLH","Internal Grade",null,null,null,"External 48 GLH","48 GLH Grade",null,null,null,null,null,null,"Award Points","Award Grade"]
["U",0,"U",null,null,0,0,"U",null,null,null,null,null,null,0,"U"]
["L1 Pass",9,"L1 Pass",null,null,0,1,"U",null,null,null,null,null,null,30,"L1 Pass"]
["L1 Merit",15,"L1 Merit",null,null,0,2,"U",null,null,null,null,null,null,44,"L1 Merit"]
["L2 Pass",22,"L2 Pass",null,null,0,3,"U",null,null,null,null,null,null,58,"L1 Distinction"]
["L2 Merit",29,"L2 Merit",null,null,0,4,"U",null,null,null,null,null,null,72,"L2 Pass"]
["L2 Distinction",36,"L2 Distinction",null,null,0,5,"U",null,null,null,null,null,null,95,"L2 Merit"]
[null,null,null,null,null,0,6,"U",null,null,null,null,null,null,105,"L2 Distinction"]
[null,null,null,null,null,0,7,"U",null,null,null,null,null,null,114,"L2 Distinction*"]
[null,null,null,null,null,0,8,"U"]
[null,null,null,null,null,0,9,"U"]
[null,null,null,null,null,0,10,"U"]
[null,null,null,null,null,0,11,"U"]
[null,null,null,null,null,12,12,"L1 Pass"]
[null,null,null,null,null,13,13,"L1 Pass"]
[null,null,null,null,null,14,14,"L1 Pass"]
[null,null,null,null,null,15,15,"L1 Pass"]
[null,null,null,null,null,16,16,"L1 Pass"]
[null,null,null,null,null,17,17,"L1 Pass"]
[null,null,null,null,null,18,18,"L1 Merit"]
[null,null,null,null,null,19,19,"L1 Merit"]
[null,null,null,null,null,20,20,"L1 Merit"]
[null,null,null,null,null,21,21,"L1 Merit"]
[null,null,null,null,null,22,22,"L1 Merit"]
[null,null,null,null,null,23,23,"L1 Merit"]
[null,null,null,null,null,24,24,"L1 Distinction"]
[null,null,null,null,null,25,25,"L1 Distinction"]
[null,null,null,null,null,26,26,"L1 Distinction"]
[null,null,null,null,null,27,27,"L1 Distinction"]
[null,null,null,null,null,28,28,"L1 Distinction"]
[null,null,null,null,null,29,29,"L1 Distinction"]
[null,null,null,null,null,30,30,"L2 Pass"]
[null,null,null,null,null,31,31,"L2 Pass"]
[null,null,null,null,null,32,32,"L2 Pass"]
[null,null,null,null,null,33,33,"L2 Pass"]
[null,null,null,null,null,34,34,"L2 Pass"]
[null,null,null,null,null,35,35,"L2 Pass"]
[null,null,null,null,null,36,36,"L2 Merit"]
[null,null,null,null,null,37,37,"L2 Merit"]
[null,null,null,null,null,38,38,"L2 Merit"]
[null,null,null,null,null,39,39,"L2 Merit"]
[null,null,null,null,null,40,40,"L2 Merit"]
[null,null,null,null,null,41,41,"L2 Merit"]
[null,null,null,null,null,42,42,"L2 Distinction"]
[null,null,null,null,null,43,43,"L2 Distinction"]
[null,null,null,null,null,44,44,"L2 Distinction"]
[null,null,null,null,null,45,45,"L2 Distinction"]
[null,null,null,null,null,46,46,"L2 Distinction"]
[null,null,null,null,null,47,47,"L2 Distinction"]
[null,null,null,null,null,48,48,"L2 Distinction"]

{"sheet":"Lookup","index":5,"n_rows":38,"n_cols":12,"rows_kept":38,"cut":false,"hidden":true,"merged":[]}
[null,null,null,"U",null,null,0,null,null,"No",0,"U"]
[null,null,null,"L1 Pass",null,null,12,null,null,"U",1,"U"]
[null,null,null,"L1 Merit",null,null,13,null,null,"L1 Pass",2,"L1 Pass"]
[null,null,null,"L2 Pass",null,null,14,null,null,"L1 Merit",3,"L1 Merit"]
[null,null,null,"L2 Merit",null,null,15,null,null,"L1 Distinction",4,"L1 Distinction"]
[null,null,null,"L2 Distinction",null,null,16,null,null,"L2 Pass",5,"L2 Pass"]
[null,null,null,null,null,null,17,null,null,"L2 Merit",6,"L2 Merit"]
[null,null,null,null,null,null,18,null,null,"L2 Distinction",7,"L2 Distinction"]
[null,null,null,null,null,null,19]
[null,null,null,null,null,null,20]
[null,null,null,null,null,null,21]
[null,null,null,null,null,null,22]
[null,null,null,null,null,null,23]
[null,null,null,null,null,null,24]
[null,null,null,null,null,null,25]
[null,null,null,null,null,null,26]
[null,null,null,null,null,null,27]
[null,null,null,null,null,null,28]
[null,null,null,null,null,null,29]
[null,null,null,null,null,null,30]
[null,null,null,null,null,null,31]
[null,null,null,null,null,null,32]
[null,null,null,null,null,null,33]
[null,null,null,null,null,null,34]
[null,null,null,null,null,null,35]
[null,null,null,null,null,null,36]
[null,null,null,null,null,null,37]
[null,null,null,null,null,null,38]
[null,null,null,null,null,null,39]
[null,null,null,null,null,null,40]
[null,null,null,null,null,null,41]
[null,null,null,null,null,null,42]
[null,null,null,null,null,null,43]
[null,null,null,null,null,null,44]
[null,null,null,null,null,null,45]
[null,null,null,null,null,null,46]
[null,null,null,null,null,null,47]
[null,null,null,null,null,null,48]

{"sheet":"Points Contingency","index":6,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
[]
["U",0,29]
["L1P",30,43]
["L1M",44,57]
["L1D",58,71]
["L2P",72,94]
["L2M",95,104]
["L2D",105,113]
["L2D*",114,120]